| satrans080808 |
| Logical Entity Name | satrans080808 |
| Default Table Name | satrans080808 |
| Physical Only | NO |
| Definition | |
| Note |
| satrans080808 Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| SaTransID | char(10) | NO | ||
| SyStudentID | char(10) | NO | ||
| AdEnrollID | char(10) | NO | ||
| Source | char(10) | NO | ||
| Type | char(10) | NO | ||
| SyCampusID | char(10) | NO | ||
| SaBillCode | char(10) | NO | ||
| TranNum | char(10) | NO | ||
| Descrip | char(10) | YES | ||
| Status | char(10) | NO | ||
| Date | char(10) | NO | ||
| PostDate | char(10) | NO | ||
| Amount | char(10) | NO | ||
| PaymentType | char(10) | YES | ||
| Discount | char(10) | NO | ||
| Payments | char(10) | NO | ||
| BatchNo | char(10) | NO | ||
| SaRevenueDetailID | char(10) | YES | ||
| FaPmtPeriodID | char(10) | NO | ||
| AcademicYear | char(10) | NO | ||
| AdTermID | char(10) | NO | ||
| Ref | char(10) | NO | ||
| CheckNo | char(10) | NO | ||
| SaCCID | char(10) | YES | ||
| ReceiptNo | char(10) | YES | ||
| DateApplied | char(10) | YES | ||
| SentBack | char(10) | NO | ||
| SaBankAccountID | char(10) | YES | ||
| SaBankDepID | char(10) | NO | ||
| AmRepID | char(10) | NO | ||
| CommRate | char(10) | NO | ||
| CommPaid | char(10) | NO | ||
| CommDate | char(10) | YES | ||
| GLPost | char(10) | NO | ||
| PostAccount | char(10) | NO | ||
| OffsetAccount | char(10) | NO | ||
| FaStudentAidID | char(10) | NO | ||
| FADisbID | char(10) | YES | ||
| FaRefundID | char(10) | YES | ||
| SaBillingBatchID | char(10) | YES | ||
| SaRefundCalcID | char(10) | YES | ||
| AddUserID | char(10) | NO | ||
| UserID | char(10) | NO | ||
| DateAdded | char(10) | NO | ||
| DateLstMod | char(10) | NO | ||
| ts | char(10) | NO | ||
| AmDepositID | char(10) | YES | ||
| CCAuthNum | char(10) | YES | ||
| CCDeclineCode | char(10) | YES | ||
| SyAddressID | char(10) | YES | ||
| SaQTBatchID | char(10) | YES | ||
| SA1098T | char(10) | NO | ||
| SaACHBatchID | char(10) | YES | ||
| DateReceiptPrinted | char(10) | YES | ||
| SaCreditCardBatchId | char(10) | YES | ||
| saCashDrawerSessionID | char(10) | YES | ||
| ManualCheckExtractFlag | char(10) | YES | ||
| AdCourseID | char(10) | YES | ||
| SaTuitionDiscountPolicyID | char(10) | YES | ||
| OriginalSaTransId | char(10) | YES | ||
| AmAgencyCCID | char(10) | YES | ||
| CheckStatus | char(10) | NO | ||
| CheckClearedDate | char(10) | YES | ||
| Sa1098TPrevYear | char(10) | NO |
| satrans080808 Primary and Unique Keys |
| Key Name | Key Type | Keys |
| satrans080808 Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| satrans080808 Check Constraints |
| Check Constraint Name | CheckConstraint |